{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": "            day           order_id  \\\n0      20231025  36629260976060800   \n1      20231025  36628579998795264   \n2      20231025  36623964307642880   \n3      20231025  36620038290074624   \n4      20231025  36628618496751744   \n...         ...                ...   \n21119  20231024  36620642684295680   \n21120  20231024  36618625448731136   \n21121  20231024  36610195457449934   \n21122  20231024  36620275552925824   \n21123  20231024  36620590419462321   \n\n                                                 feature final_judge_type  \\\n0      {\"driver_id\":600608457553025592,\"finish_num_15...              NaN   \n1      {\"driver_id\":4000000043847163492,\"finish_num_1...          shipper   \n2      {\"driver_id\":4000000038408274108,\"orderpositio...          shipper   \n3      {\"driver_id\":4000000028962080594,\"finish_num_1...          shipper   \n4      {\"driver_id\":4000000041190875553,\"finish_num_1...          shipper   \n...                                                  ...              ...   \n21119  {\"driver_id\":4000000043477483396,\"orderpositio...          shipper   \n21120  {\"driver_id\":4000000014858608613,\"orderpositio...          shipper   \n21121  {\"driver_id\":4000000038525383102,\"finish_num_1...      scene_judge   \n21122  {\"driver_id\":600608457517728367,\"finish_num_15...              NaN   \n21123  {\"driver_id\":4000000047138157317,\"finish_num_1...          shipper   \n\n      special_judge_strength importantfeaturelist  \n0                        NaN                  NaN  \n1                        NaN                  NaN  \n2                        NaN                  NaN  \n3                        NaN                  NaN  \n4                        NaN                  NaN  \n...                      ...                  ...  \n21119                    NaN                  NaN  \n21120                    NaN                  NaN  \n21121                    NaN                  NaN  \n21122                    NaN                  NaN  \n21123                    NaN                  NaN  \n\n[21124 rows x 6 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>day</th>\n      <th>order_id</th>\n      <th>feature</th>\n      <th>final_judge_type</th>\n      <th>special_judge_strength</th>\n      <th>importantfeaturelist</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>20231025</td>\n      <td>36629260976060800</td>\n      <td>{\"driver_id\":600608457553025592,\"finish_num_15...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>20231025</td>\n      <td>36628579998795264</td>\n      <td>{\"driver_id\":4000000043847163492,\"finish_num_1...</td>\n      <td>shipper</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>20231025</td>\n      <td>36623964307642880</td>\n      <td>{\"driver_id\":4000000038408274108,\"orderpositio...</td>\n      <td>shipper</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>20231025</td>\n      <td>36620038290074624</td>\n      <td>{\"driver_id\":4000000028962080594,\"finish_num_1...</td>\n      <td>shipper</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>20231025</td>\n      <td>36628618496751744</td>\n      <td>{\"driver_id\":4000000041190875553,\"finish_num_1...</td>\n      <td>shipper</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>21119</th>\n      <td>20231024</td>\n      <td>36620642684295680</td>\n      <td>{\"driver_id\":4000000043477483396,\"orderpositio...</td>\n      <td>shipper</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>21120</th>\n      <td>20231024</td>\n      <td>36618625448731136</td>\n      <td>{\"driver_id\":4000000014858608613,\"orderpositio...</td>\n      <td>shipper</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>21121</th>\n      <td>20231024</td>\n      <td>36610195457449934</td>\n      <td>{\"driver_id\":4000000038525383102,\"finish_num_1...</td>\n      <td>scene_judge</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>21122</th>\n      <td>20231024</td>\n      <td>36620275552925824</td>\n      <td>{\"driver_id\":600608457517728367,\"finish_num_15...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>21123</th>\n      <td>20231024</td>\n      <td>36620590419462321</td>\n      <td>{\"driver_id\":4000000047138157317,\"finish_num_1...</td>\n      <td>shipper</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>21124 rows × 6 columns</p>\n</div>"
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "file = r'D:\\迅雷下载\\20231026.csv'\n",
    "df = pd.read_csv(file,sep=\"\\001\")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "outputs": [
    {
     "data": {
      "text/plain": "{'driver_id': 600608457553025592,\n 'finish_num_15days': 3,\n 'orderpositionresponselistnum': 19,\n 'is_fk': 0,\n 'cargodtomintruckweight': 0.0,\n 'is_new_register_driver': 0,\n 'driverlocationrequest': {'traceInfoList': [{'traceId': '',\n    'cargoId': 44622599958835,\n    'shipperId': 4000000043037948835,\n    'orderId': 36629260976060800,\n    'loadPoint': {'poiName': '蓬勃果业',\n     'changeType': 1,\n     'lon': 113.227809,\n     'cityId': 440100,\n     'pointType': 1,\n     'provinceId': 440000,\n     'score': 0.0,\n     'poiAddress': '中国广东省广州市白云区',\n     'cityName': '广州市',\n     'countyId': 440111,\n     'poiType': 3,\n     'isAttached': False,\n     'provinceName': '广东省',\n     'lat': 23.169745,\n     'countyName': '白云区'},\n    'unloadPointList': [{'poiName': '牛犇财富大厦',\n      'changeType': 1,\n      'lon': 113.237603,\n      'cityId': 440100,\n      'pointType': 2,\n      'provinceId': 440000,\n      'score': 0.0,\n      'poiAddress': '广东省广州市白云区石槎路聚源街50号(白云欣凯科创园2号楼)',\n      'cityName': '广州市',\n      'countyId': 440111,\n      'poiType': 3,\n      'isAttached': False,\n      'provinceName': '广东省',\n      'lat': 23.184079,\n      'countyName': '白云区'}],\n    'startTraceList': [{'lon': 113.22469716459514,\n      'lat': 23.16964886521825,\n      'timestamp': 1698200748038},\n     {'lon': 113.22485703848457,\n      'lat': 23.170382284655737,\n      'timestamp': 1698200848053}],\n    'endTraceList': [[]]}]},\n 'truckdtoupdatetime': 1697776682000,\n 'dhbzpredictres': 0,\n 'flpredictres': 0,\n 'cargodtohandlingtype': 1,\n 'cargodtocreatetime': 1698200189000,\n 'bad_comment_rate': 0.0,\n 'shippercommentstatus': 3,\n 'cargodtopaystatus': 30,\n 'shipperid': 4000000043037948835,\n 'cargo_view_duration_14d': 0,\n 'cargodtotrucklength': '1.8',\n 'cargodtosecondcategoryid': 0,\n 'is_lastmonthord_thismonthnoord': 0,\n 'textflag': False,\n 'tradeorderdtodepositflag': 2,\n 'income_last_week': 0.0,\n 'is_new_user': 0,\n 'loadalgodistance': -1,\n 'is_not_window': 0,\n 'cargodtoinvalidreason': 0,\n 'truck_length': 2.7,\n 'callrecorddtoshippercallnums': 0,\n 'cargodtoend': 440111,\n 'avg_finishnum_thismonth': 1,\n 'order_exact_truck_type_rate_14d': 1.0,\n 'ttl_city_rank': 1,\n 'algorithmResortThreshold': 0.35,\n 'cargodtopackingtype': '',\n 'cargodtoendcoordinatelongitude': 113.237603,\n 'order_cnt_14d': 21,\n 'cargodtocompanyid': 0,\n 'unloadtimetimeflag': False,\n 'is_cz': 0,\n 'callrecorddtodrivercallnums': 1,\n 'sjyspredictres': 0,\n 'truck_plate_color': 2,\n 'tradeorderdtocarrieruserdtoloaddurationtime': 120,\n 'tradeorderdtoconsignoruserversion': '1821715',\n 'asrtext': '货主：啊。$_$司机：哎哎。$_$货主：啊。$_$司机：是拉货的，你这里在哪里装啊？$_$货主：到出口交站就行了。$_$货主：不用定在市场公平市场啊。$_$司机：哦。$_$司机：哦，不用进来，直接的加油站给你哈。$_$货主：对对对，在那里就嗯啊。$_$司机：呃。$_$司机：哦，行，我大概五分钟到那里。$_$货主：好，行行啊，嗯嗯啊。$_$司机：嗯，好。@_@货主：为保证服务质量，通话将被录音。$_$司机：喂，你好啊，我4米，机械水果过来，您这里是在哪里啊？$_$货主：喂喂。$_$货主：啊，你好。$_$货主：刘敦财富大厦。$_$司机：那个导航我导到大车，但是前面遂昌没有路了。$_$货主：哪里？哪个当乡？$_$司机：安鸿运啊。$_$货主：鸿瑞大厦。$_$司机：对啊，那个科技。$_$货主：不是那里，你看你你那里有没有看到停车场下去负一楼的？$_$司机：啊，你导航给我找到我就过不去了。$_$货主：喂。$_$货主：没有没有看到负一楼停车场那个标志。$_$司机：嗯，停车场啊。$_$货主：对，那边可以下去的。$_$司机：嗯。$_$司机：你你那意思就是说我要跟你拉到地乡是吗？$_$货主：对对对是的。$_$司机：提车，这里很金海园这个路口这里嘛。$_$货主：好嘞。$_$货主：对啊，负一。$_$司机：附近的话。$_$司机：在哪？哪哪个位置啊？$_$货主：呃，二号到我在那个电梯口等你。$_$司机：呃，付一和二吨是下去是左转右转，还是我要下去找？$_$货主：你不用上去早就是在就是负一那里就有啦，我就在那个电梯口。$_$司机：我现在在三至这里写着有个三次山东啊。$_$货主：你先去付一没有？$_$司机：我现在正在那个口这里还没下。$_$货主：那你先下去啊。$_$司机：啊，那下来吧哈。$_$货主：啊，对，你找到那个二号口那个，呃呃，二号到写个牛顿财富到下载那个电梯口，我就在那里等你。$_$司机：男装空车很多很多吗啊？对，我打他二号东啊。对对对对对，您下来嘛哈嗯。$_$货主：嗯，行嗯。$_$司机：嗯。',\n 'is_experience_express_member_driver': 0,\n 'truckdtoplatecolor': 2,\n 'driver2laborStartCities': ['苏州市'],\n 'loadinfolist': [{'loadOnAddress': 0,\n   'loadArrivalMode': 0,\n   'loadPOIName': '广东省广州市白云区松洲{{OAKYAB}}路{M}',\n   'loadOnTime': 1,\n   'loadPOIDistance': '434米'}],\n 'querycallrecordresponse': {'totalCount': 2,\n  'resultList': [{'callId': 'C20231025101947AC10212083528509176',\n    'callerNum': '999198302724699176',\n    'middleNum': '17589165974',\n    'bizType': 'shortDistance',\n    'calledRelCause': '1',\n    'disconnectTime': 1698200424000,\n    'businessId': '44622599958835',\n    'aRelId': '600608457553025592',\n    'callInTime': 1698200399000,\n    'bindId': '16982003821747661343538',\n    'duration': 26,\n    'cargoId': 44622599958835,\n    'providerId': 1,\n    'bizId': '44622599958835',\n    'phoneB': '999134122233562191',\n    'callerType': 1,\n    'calledNum': '999134122233562191',\n    'callOutTime': 1698200392000,\n    'bRelId': '4000000043037948835',\n    'phoneA': '999198302724699176',\n    'status': 7},\n   {'callId': '202310251041594599114923159',\n    'callerNum': '999198302724699176',\n    'middleNum': '18668482049',\n    'bizType': 'unloadingContact',\n    'calledRelCause': 'ANSWERED',\n    'disconnectTime': 1698201853000,\n    'businessId': '44622599958835',\n    'aRelId': '600608457553025592',\n    'callInTime': 1698201726000,\n    'bindId': '16982017135017661692702',\n    'duration': 127,\n    'providerId': 2,\n    'bizId': '44622599958835',\n    'phoneB': '999135443535345143',\n    'callerType': 1,\n    'calledNum': '999135443535345143',\n    'callOutTime': 1698201719000,\n    'bRelId': '80135443535345143',\n    'phoneA': '999198302724699176',\n    'status': 7}]},\n 'driver2laborReasonIds': [],\n 'unloadaddrflag': False,\n 'tradeorderdtototalfreightamount': 3502,\n 'driver_level_score': 103.0,\n 'cy_ratio': 0.3333333333333333,\n 'loadpictime': 1698200883000,\n 'loadpoidistance': -10,\n 'loadaddrtimeflag': True,\n 'tradeorderdtodealtime': 1698200356000,\n 'start_city_name': '广州市',\n 'cargodtostartcoordinatelongitude': 113.227809,\n 'unloadpictime': 1698201953000,\n 'trucknotmatch': 0,\n 'cargodtotraceid': '1698200161778-902a-42e3-a0ae-62751bfc403e',\n 'cargo_gap': 2.0,\n 'cargo_this_week': 2,\n 'cargodtoupdatetime': 1698200356000,\n 'cargodtotrucktypelist': '13',\n 'start_buss_district_top1': '白云区-江南市场',\n 'complain_rate': 0.0,\n 'cargodtocargostatus': 30,\n 'cargodtoestimatedistancekm': 5,\n 'unloadpictimediff': -803000,\n 'cargodtomaxcargocapacipy': 0.0,\n 'loadaddrvague': False,\n 'cargodtoextraprice': 0,\n 'tradeorderdtocreatetime': 1698200189701,\n 'cargodtounloadingadress': '广东省广州市白云区石槎路聚源街50号(白云欣凯科创园2号楼)',\n 'unloadactualtime': 1698201268000,\n 'loadpictimediff': -74000,\n 'driverpriceconfidence': 0.0,\n 'cargodtoplatformprice': 3502,\n 'cargodtoloadaddress': '中国广东省广州市白云区',\n 'finish_num_30days_group': '中频',\n 'tradeorderdtosupportfreight': 0,\n 'avg_service_score': 119.0,\n 'driverpricetype': 0.0,\n 'loadaddrpoidistance': 434,\n 'driver_income_7d': 70.33,\n 'city_id': 440100,\n 'cargodtotagsjson': '{\"valueMap\":{\"virtualContactCargo\":{\"id\":\"virtualContactCargo\",\"startTime\":1698201954219,\"valid\":true},\"genesis_page\":{\"id\":\"genesis_page\",\"startTime\":1698201954219,\"valid\":true},\"new_short_distance_cargo\":{\"id\":\"new_short_distance_cargo\",\"startTime\":1698201954219,\"valid\":true},\"DepositGuarantee\":{\"id\":\"DepositGuarantee\",\"startTime\":1698201954219,\"valid\":true},\"standardCargo\":{\"id\":\"standardCargo\",\"startTime\":1698201954219,\"valid\":true},\"hit_carry_service_gray\":{\"id\":\"hit_carry_service_gray\",\"startTime\":1698201954219,\"valid\":true},\"getNavigationDistanceAlreadyForAdd\":{\"id\":\"getNavigationDistanceAlreadyForAdd\",\"startTime\":1698201954219,\"valid\":true}}}',\n 'cargodtoexpectfreight': 3502,\n 'tradeorderdtodrivercommissionstatus': -1,\n 'cargodtoendcoordinatelatitude': 23.184079,\n 'cargoid': 44622599958835,\n 'city_name': '广州市',\n 'pricewaitingfeedtoovertimewaitduration': 0,\n 'cargodtoestimatedistance': 5000,\n 'tradeorderdtodriverauthstatus': 127,\n 'tradeorderdtoordertimingtype': 2,\n 'cargodtofirstcategoryid': 0,\n 'orderid': 36629260976060800,\n 'tradeorderdtoupdatetime': 1698201954000,\n 'unloadaddrpoidistance': -1000,\n 'cargodtostartloaddatetime': 1698200789270,\n 'pricewaitingfeedtototalwaitduration': 0,\n 'cargodtomincargocapacipy': 0.0,\n 'truckdtoauditdesc': '',\n 'cargodtoconsigneetel': '999134122233562191',\n 'tradeorderdtodrivercarry': False,\n 's_cnt_ratio': 0.0,\n 'isunloadonloac': 1,\n 'loadtegulatytime': 1698200957000,\n 'is_truckline_label': 1,\n 'ggzxdzpredictres': 0,\n 'isunloadontime': 1,\n 'hasexchangedcontact': 0,\n 'is_bad_sticker_driver': 0,\n 'unloadalgodistance': -1,\n 'income_last_2week': 0.0,\n 'truckdtotrucklength': 2.7,\n 'isloadontime': 1,\n 'unloadtegulatytime': 1698202756000,\n 'drivercommentstatus': 3,\n 'driverid': 600608457553025592,\n 'tradeorderdtosecuritytran': 0,\n 'cargodtocargochannel': 53,\n 'bz_ratio': 0.0,\n 'cargo_last_week': 1,\n 'shipper_heat': 0.0,\n 'cargodtopaymentway': 1,\n 'tradeorderdtocarrieruserdtoloaddistance': 494,\n 'appear_duration_7d': 850,\n 'driver_income_per_hour': 4.64,\n 'pk_success_rate_7d': 0.2857,\n 'cargodtoispackage': 0,\n 'driver_level': '普通司机',\n 'cargodtomaxtruckweight': 0.0,\n 'pk_rank': 0.57,\n 'cargodtocargostevedoreextlist': [{'contactTelephone': '999134122233562191',\n   'districtName': '白云区',\n   'poiName': '蓬勃果业',\n   'isValid': 1,\n   'orderBy': 1,\n   'lon': '113.227809',\n   'updateTime': 1698200189000,\n   'cityId': 440100,\n   'type': 0,\n   'provinceId': 440000,\n   'cargoId': 44622599958835,\n   'districtId': 440111,\n   'cityName': '广州市',\n   'originalAddress': '中国广东省广州市白云区',\n   'createTime': 1698200189000,\n   'detailAddress': '中国广东省广州市白云区',\n   'exactCoordinate': 1,\n   'contactAddress': '',\n   'id': 4479853577,\n   'provinceName': '广东省',\n   'lat': '23.169745'},\n  {'contactTelephone': '999135443535345143',\n   'districtName': '白云区',\n   'poiName': '牛犇财富大厦',\n   'contactName': '',\n   'isValid': 1,\n   'orderBy': 2,\n   'lon': '113.237603',\n   'updateTime': 1698200189000,\n   'cityId': 440100,\n   'type': 1,\n   'provinceId': 440000,\n   'cargoId': 44622599958835,\n   'districtId': 440111,\n   'cityName': '广州市',\n   'originalAddress': '广东省广州市白云区石槎路聚源街50号(白云欣凯科创园2号楼)',\n   'createTime': 1698200189000,\n   'detailAddress': '广东省广州市白云区石槎路聚源街50号(白云欣凯科创园2号楼)',\n   'exactCoordinate': 1,\n   'contactAddress': '',\n   'id': 4479853578,\n   'provinceName': '广东省',\n   'lat': '23.184079'}],\n 'callrecorddtodrivernotanswernums': 0,\n 'drivertargetprice': 0.0,\n 'tradeorderdtocargopublishchannel': 53,\n 'callrecorddtoshippernotanswernums': 0,\n 'loadandunloadtime': {'finishLoadTime': 1698200884000,\n  'haveLoadDestinationTime': 1698200719000,\n  'finishUnLoadTime': 1698201953000,\n  'haveUnLoadDestinationTime': 1698201859000},\n 'income_last_month': 279.54,\n 'cargodtocargotype': -1,\n 'algorithmShipperStrongThreshold': 0.95,\n 'a_cnt_ratio': 0.0,\n 'is_margin': 0,\n 'is_not_message': 0,\n 'listening_list_duration_14d': 0,\n 'cargodtoloaddatetimetwfh': 1698246000000,\n 'pk_cargo_cnt_7d': 7,\n 'truckdtologo': '',\n 'cargodtostartcoordinatelatitude': 23.169745,\n 'income_curr_month': 100.78,\n 'cargodtoendloaddatetime': 1698200789270,\n 'cargodtotruckweight': 0.0,\n 'cargodtocargocapacipy': 0.0,\n 'is_new_sticker_driver': 0,\n 'isloadonloac': 0,\n 'self_type': '共有',\n 'add_days': 146,\n 'shipper_id': 4000000043037948835,\n 'income_curr_week': 70.33,\n 'unloadaddrvague': False,\n 'cargodtosecuritytran': 0,\n 'fh_num': 28,\n 'finish_num': 20,\n 'is_intention_driver': 0,\n 'loadactualtime': 1698200719000,\n 'is_jq': 0,\n 'is_new_express_member_driver': 0,\n 'order_exact_truck_type_cnt_14d': 0,\n 'truckdtotruckload': 1.0,\n 'driver_level_new': '[]',\n 'whole2laborStartCities': ['苏州市'],\n 'loadpoisimilarity': 0.0,\n 'work_duration_7d': 110,\n 'avg_finishnum_lastmonth': 1,\n 'loadmingeodistance': 310,\n 'truckdtocreatetime': 1522744427000,\n 'is_new_month_member_driver': 0,\n 'tradeorderdtooutsidesource': 2,\n 'newordernotfinishedidlist': [],\n 'unloadpoisimilarity': 0.6666666,\n 'tradeorderdtodealhour': 10,\n 'cargodtomanualtime': 1698200189000,\n 'haspenaltyzone': 0,\n 'cargohasordered': 0,\n 'cargodtodescription': '',\n 'orderpositionresponseaddressnum': 17,\n 'xddzbxxpredictres': 1,\n 'online_duration_7d': 910,\n 'finish_num_30days': 7,\n 'shipper_tag_1': '稳定',\n 'is_not_call': 0,\n 'shipper_tag_2': '稳定',\n 'truck_type': 13,\n 'cargodtounloadingpoiname': '牛犇财富大厦',\n 'tradeorderdtodriverarriveunloadcount': 1,\n 'tradeorderdtoshortdistancedtodriverproductid': 5033706,\n 'cargodtoloadpoiname': '蓬勃果业',\n 'cargodtosecuredtran': 5,\n 'sticker_status': '未贴',\n 'arriveloadunloadtimediff': 549000,\n 'unloadinfolist': [{'arrivalMode': 1,\n   'onTime': 1,\n   'poiName': '广东省广州市白云区松洲街道西槎路{{JrPIKSRgj}}区{M}',\n   'onAddress': 1,\n   'poiDistance': '387米',\n   'order': 1}],\n 'income_last_2month': 395.18,\n 'income_last_3week': 30.45,\n 'service_score': 103.0,\n 'pricewaitingfeedtoremainfreewaitduration': 2400,\n 'unloadaddrtimeflag': False,\n 'algorithmStrengthThreshold': 0.3,\n 'unloadmingeodistance': 113,\n 'loadaddrflag': False,\n 'is_factory_label': 0,\n 'cargodtopackingtypetags': '',\n 'loadtimetimeflag': False,\n 'tradeorderdtocreatehour': 10,\n 'cargodtoloaddatetime': 1698200789000,\n 'pricenotagreement': -1,\n 'cj_ratio': 0.0,\n 'resident_prov': '广东省',\n 'cancel_rate': 0.0,\n 'xgpredictres': 0,\n 'cargodtostart': 440111,\n 'is_good_sticker_driver': 0,\n 'tradeorderdtoactualfreightamount': 3502,\n 'calllogtexts': [{'callId': 'C20231025101947AC10212083528509176',\n   'content': 'B:啊。$_$A:哎哎。$_$B:啊。$_$A:是拉货的，你这里在哪里装啊？$_$B:到出口交站就行了。$_$B:不用定在市场公平市场啊。$_$A:哦。$_$A:哦，不用进来，直接的加油站给你哈。$_$B:对对对，在那里就嗯啊。$_$A:呃。$_$A:哦，行，我大概五分钟到那里。$_$B:好，行行啊，嗯嗯啊。$_$A:嗯，好。'},\n  {'callId': '202310251041594599114923159',\n   'content': 'B:为保证服务质量，通话将被录音。$_$A:喂，你好啊，我4米，机械水果过来，您这里是在哪里啊？$_$B:喂喂。$_$B:啊，你好。$_$B:刘敦财富大厦。$_$A:那个导航我导到大车，但是前面遂昌没有路了。$_$B:哪里？哪个当乡？$_$A:安鸿运啊。$_$B:鸿瑞大厦。$_$A:对啊，那个科技。$_$B:不是那里，你看你你那里有没有看到停车场下去负一楼的？$_$A:啊，你导航给我找到我就过不去了。$_$B:喂。$_$B:没有没有看到负一楼停车场那个标志。$_$A:嗯，停车场啊。$_$B:对，那边可以下去的。$_$A:嗯。$_$A:你你那意思就是说我要跟你拉到地乡是吗？$_$B:对对对是的。$_$A:提车，这里很金海园这个路口这里嘛。$_$B:好嘞。$_$B:对啊，负一。$_$A:附近的话。$_$A:在哪？哪哪个位置啊？$_$B:呃，二号到我在那个电梯口等你。$_$A:呃，付一和二吨是下去是左转右转，还是我要下去找？$_$B:你不用上去早就是在就是负一那里就有啦，我就在那个电梯口。$_$A:我现在在三至这里写着有个三次山东啊。$_$B:你先去付一没有？$_$A:我现在正在那个口这里还没下。$_$B:那你先下去啊。$_$A:啊，那下来吧哈。$_$B:啊，对，你找到那个二号口那个，呃呃，二号到写个牛顿财富到下载那个电梯口，我就在那里等你。$_$A:男装空车很多很多吗啊？对，我打他二号东啊。对对对对对，您下来嘛哈嗯。$_$B:嗯，行嗯。$_$A:嗯。'}],\n 'unloadpoidistance': 10,\n 'truckdtotrucktype': 13,\n 'cargodtoshowendtime': 1698203798000,\n 'resident_city': '广州市',\n 'cargodtolclcargo': 0,\n 'truckdtoplate': '粤ANMPjsRO8#',\n 'loadtimediff': 0,\n 'ordernotfinishedidlist': [],\n 'is_sticker': 0,\n 'dcpredictres': 0,\n 'cargodtocargoname': '',\n 'callrecorddtoallcallnums': 1,\n 'cargodtotrucktype': 13,\n 'punctualityscene': ['LOAD_ON_ADDR'],\n 'jtsgpredictres': 0,\n 'whole2laborReasonIds': [],\n 'tradeorderdtorisktime': 1698201953375,\n 'pk_success_cnt_7d': 2}"
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import json\n",
    "a= json.loads(df['feature'][0])\n",
    "a"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "'bizcode'",
     "output_type": "error",
     "traceback": [
      "\u001B[1;31m---------------------------------------------------------------------------\u001B[0m",
      "\u001B[1;31mKeyError\u001B[0m                                  Traceback (most recent call last)",
      "Input \u001B[1;32mIn [7]\u001B[0m, in \u001B[0;36m<cell line: 1>\u001B[1;34m()\u001B[0m\n\u001B[1;32m----> 1\u001B[0m \u001B[43ma\u001B[49m\u001B[43m[\u001B[49m\u001B[38;5;124;43m'\u001B[39;49m\u001B[38;5;124;43mbizcode\u001B[39;49m\u001B[38;5;124;43m'\u001B[39;49m\u001B[43m]\u001B[49m\n",
      "\u001B[1;31mKeyError\u001B[0m: 'bizcode'"
     ]
    }
   ],
   "source": [
    "a['bizcode']"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "need_types = [\"司机抢错单\",\"司机爽约\",\"司机没有主动联系货主\", \"线下交易2\"]\n",
    "\n",
    "for check in need_types:\n",
    "    pd_filter = df[df[\"importantfeaturelist\"].str.contains(check)]\n",
    "    pd_filter.sample(frac=1.0)\n",
    "    pd_save = pd_filter.iloc[:50,:]\n",
    "    pd_save = pd_save[\"\"]\n",
    "    pd_save.to_excel()"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}